USE DB_TCC
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME LIKE 'P_CURRICULO_REDE_SOCIAL_LISTAR')
	DROP PROCEDURE P_CURRICULO_REDE_SOCIAL_LISTAR
GO
CREATE PROCEDURE P_CURRICULO_REDE_SOCIAL_LISTAR(
	@IDCURRICULO INTEGER)
AS BEGIN
	SELECT
		IDREDESOCIAL,
		IDCURRICULO,
		LINKREDESOCIAL,
		DTHRINCLUSAO,
		DTHRALTERACAO
	FROM
		CURRICULO_REDE_SOCIAL
	WHERE
		IDCURRICULO = @IDCURRICULO
END